sqlx4k-mysql/io.github.smyrgeorge.sqlx4k.mysql/[native]MySQL/SqlxTransaction

SqlxTransaction

class SqlxTransaction : Transaction(source)

Constructors

SqlxTransaction

constructor(rt: CPointer<out CPointed>, tx: CPointer<out CPointed>, encoders: ValueEncoderRegistry)

Properties

commited

open override val commited: Boolean

encoders

open override val encoders: ValueEncoderRegistry

rollbacked

open override val rollbacked: Boolean

status

open override val status: Transaction.Status

Functions

assertIsOpen

open fun assertIsOpen()

commit

open suspend override fun commit(): Result<Unit>

execute

open suspend override fun execute(statement: Statement): Result<Long>

open suspend override fun execute(sql: String): Result<Long>

executeWithResult

open suspend override fun executeWithResult(statement: Statement): Result<ExecuteResult>

open suspend override fun executeWithResult(sql: String): Result<ExecuteResult>

fetch

open fun <T> fetch(statement: Statement, rowMapper: RowMapper<T>, fetchSize: Int): Flow<T>

open fun <T> fetch(@Language(value = "SQL") sql: String, rowMapper: RowMapper<T>, fetchSize: Int): Flow<T>

open override fun fetch(statement: Statement, fetchSize: Int): Flow<ResultSet.Row>

open override fun fetch(sql: String, fetchSize: Int): Flow<ResultSet.Row>

fetchAll

open suspend fun <T> fetchAll(statement: Statement, rowMapper: RowMapper<T>): Result<List<T>>

open suspend fun <T> fetchAll(@Language(value = "SQL") sql: String, rowMapper: RowMapper<T>): Result<List<T>>

open suspend override fun fetchAll(statement: Statement): Result<ResultSet>

open suspend override fun fetchAll(sql: String): Result<ResultSet>

releaseSavepoint

open suspend fun releaseSavepoint(name: String): Result<Unit>

rollback

open suspend override fun rollback(): Result<Unit>

rollbackToSavepoint

open suspend fun rollbackToSavepoint(name: String): Result<Unit>

savepoint

open suspend fun savepoint(name: String): Result<Unit>

open suspend fun <T> savepoint(name: String, f: suspend Transaction.() -> T): Result<T>

withReadBackTransaction

suspend fun <T> QueryExecutor.withReadBackTransaction(block: suspend (QueryExecutor) -> Result<T>): Result<T>

Runs block, a write and the read back of the row it wrote, in a single transaction: this executor itself when it is one, else one begun on it (on a connection of its own, when a pool), committed when block succeeds and rolled back when it fails.

withSingleConnection

suspend fun <T> QueryExecutor.withSingleConnection(block: suspend (QueryExecutor) -> Result<T>): Result<T>

Runs block on a single database connection: this executor itself when it already is one (a connection or a transaction), or a connection borrowed from it for the duration of block when it is a pool.